import pandas as pd
data = pd.read_excel('F:\\python\\第7章\\销售表.xlsx', sheet_name=0)
a = data.groupby(by='产品名称')
b = a['销售数量'].sum()
print(b)
print()
c = a[['销售数量', '利润']].sum()
print(c)
